{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ВПР - точный поиск"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ВПР - точный поиск","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,3],[10,4,12,4],[10,1,12,1]]}
[]
[]
[null,null,"При продажах больше","ставка премии"]
[null,null,100,0.04]
[null,null,200,0.05]
[null,null,300,0.06]
[null,null,400,7.0000000000000007E-2]
[null,null,500,0.08]
[]
["нажмите на плюс/минус слева, чтобы посмотреть/скрыть решение"]
[null,"решение","Фактические продажи:",350,"решение"]
[null,null,"Ставка премии:",{"$f":"VLOOKUP(D11,C3:D8,2,TRUE)","v":0.06}]
[null,null,"Премия:",{"$f":"D11*D12","v":21}]
[]
[null,null,"Фактические продажи:",350]
[null,null,"Ставка премии:",null,"напишите формулу \nслева от этого текста"]
[null,null,"Премия:",{"$f":"D15*D16","v":0}]